Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# $STORETRIGGERVAL

The $STORETRIGGERVAL property specifies whether or not, when a $NATRIGGER expression executes, Oracle OLAP replaces the `NA` values in the variable with the results of the expression.

Note: Applications typically use the $VARCACHE property rather than the $STORETRIGGERVAL property since the functionality of the $STORETRIGGERVAL property is subsumed within the $VARCACHE property.

See also: "How Oracle OLAP Determines Whether to Store or Cache Results of $NATRIGGER".

Syntax

You add or delete a $STORETRIGGERVAL property to the most recently defined or considered object (see DEFINE and CONSIDER) using a PROPERTY statement:

- To add the property, issue the following statement.

  PROPERTY '$STORETRIGGERVAL' value

- To delete the property, issue the following statement.

  PROPERTY DELETE '$ASTORETRIGGERVAL'

Arguments

value

  A BOOLEAN expression that contains the value of the property.

Examples

Example 6-12 Storing an $NATRIGGER Property Value

The following statements cause Oracle OLAP to store the $NATRIGGER expression value in the `NA` cells of the `v1` variable when Oracle OLAP evaluates the expression.

    TRIGGERSTOREOK = yes
    CONSIDER v1
    PROPERTY '$STORETRIGGERVAL' yes